Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerID (FK)(PK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | Customer(PA_CT) |
CustomerAssetID (FK)(PK) | A unique, automatically assigned identifier for an asset or other item of interest that belongs to or is related to a customer. | ID_CT_AST | Identity | integer | CustomerAsset(PA_CT_AST) |
OwnedSinceDate | A self-reported original ownership/lease/acquisition date for a CUSTOMER ASSET. | DC_OWN | DateCalendar | date | |
VerifiedDate | The date that an asset is verified as being in the possession of a CUSTOMER. | DC_VR | DateCalendar | date | |